﻿CREATE TABLE [dbo].[DBCurrency] (
    [ID]             UNIQUEIDENTIFIER NOT NULL,
    [Country]        VARCHAR (55)     NOT NULL,
    [CurrencyName]   VARCHAR (55)     NOT NULL,
    [Ticker]         CHAR (3)         NOT NULL,
    [ReferencePrice] FLOAT            NULL,
    PRIMARY KEY CLUSTERED ([ID] ASC) WITH (ALLOW_PAGE_LOCKS = ON, ALLOW_ROW_LOCKS = ON, PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF, STATISTICS_NORECOMPUTE = OFF),
    UNIQUE NONCLUSTERED ([Country] ASC, [Ticker] ASC) WITH (ALLOW_PAGE_LOCKS = ON, ALLOW_ROW_LOCKS = ON, PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF, STATISTICS_NORECOMPUTE = OFF)
);

